﻿CREATE TABLE [dbo].[AngajatiStatPlata] (
    [IDStatPlata]         INT             IDENTITY (1, 1) NOT NULL,
    [IDTipStatPlata]      SMALLINT        NOT NULL,
    [IDPersoana]          INT             NOT NULL,
    [IDAngajatSalarizare] INT             NOT NULL,
    [Suma]                DECIMAL (18, 2) CONSTRAINT [DF_AngajatiStatPlata_Suma] DEFAULT ((0)) NOT NULL,
    [Anul]                SMALLINT        CONSTRAINT [DF_AngajatiStatPlata_Anul] DEFAULT ((2000)) NOT NULL,
    [Luna]                SMALLINT        CONSTRAINT [DF_AngajatiStatPlata_Luna] DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_AngajatiStatPlata] PRIMARY KEY CLUSTERED ([IDStatPlata] ASC)
);

